<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Servers Table</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="DataparkSearch Engine 4.52"
HREF="index.en.html"><LINK
REL="UP"
TITLE="Indexing"
HREF="dpsearch-indexing.en.html"><LINK
REL="PREVIOUS"
TITLE="Aliases"
HREF="dpsearch-aliases.en.html"><LINK
REL="NEXT"
TITLE="External parsers"
HREF="dpsearch-pars.en.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="datapark.css"><META
NAME="Description"
CONTENT="DataparkSearch - Full Featured Web site Open Source Search Engine Software over the Internet and Intranet Web Sites Based on SQL Database. It is a Free search software covered by GNU license."><META
NAME="Keywords"
CONTENT="shareware, freeware, download, internet, unix, utilities, search engine, text retrieval, knowledge retrieval, text search, information retrieval, database search, mining, intranet, webserver, index, spider, filesearch, meta, free, open source, full-text, udmsearch, website, find, opensource, search, searching, software, udmsearch, engine, indexing, system, web, ftp, http, cgi, php, SQL, MySQL, database, php3, FreeBSD, Linux, Unix, DataparkSearch, MacOS X, Mac OS X, Windows, 2000, NT, 95, 98, GNU, GPL, url, grabbing"></HEAD
><BODY
CLASS="SECT1"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000C4"
VLINK="#1200B2"
ALINK="#C40000"
><!--#include virtual="body-before.html"--><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>DataparkSearch Engine 4.52: Reference manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="dpsearch-aliases.en.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 3. Indexing</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="dpsearch-pars.en.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="SRVTABLE"
>3.8. Servers Table</A
></H1
><A
NAME="AEN1189"
></A
><P
><SPAN
CLASS="APPLICATION"
>DataparkSearch</SPAN
> has <B
CLASS="COMMAND"
>ServerTable</B
>
<TT
CLASS="FILENAME"
>indexer.conf</TT
> command. It allow load servers and filters configuration from SQL table. </P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="SRVTABLE-LOAD"
>3.8.1. Loading servers table</A
></H2
><P
>When <B
CLASS="COMMAND"
>ServerTable mysql://user:pass@host/dbname/tablename[?srvinfo=infotablename]</B
>
is specified, indexer will load
servers information from given <TT
CLASS="LITERAL"
>tablename</TT
> SQL table, and will load servers parameters
from given <TT
CLASS="LITERAL"
>infotablename</TT
> SQL table. If <TT
CLASS="LITERAL"
>srvinfo</TT
> parameter is not specified,
parameters will be loaded from <TT
CLASS="LITERAL"
>srvinfo</TT
> table. Check the structure for <TT
CLASS="LITERAL"
>server</TT
> and
<TT
CLASS="LITERAL"
>srvinfo</TT
> tables in <TT
CLASS="FILENAME"
>create/mysql/create.txt</TT
> file. If there is no
structure example for your database, take it as an example.</P
><P
>You may use several <B
CLASS="COMMAND"
>ServerTable</B
> command to load servers information from different tables.</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="SRVTABLE-STRUCTURE"
>3.8.2. Servers table structure</A
></H2
><P
>Servers table consists of all necessary fields which
describe servers parameters. Field names have correspondent
<TT
CLASS="FILENAME"
>indexer.conf</TT
> commands. For example, "period"
field corresponds "Period" <TT
CLASS="FILENAME"
>indexer.conf</TT
>
command. Default field values are the same with default
<TT
CLASS="FILENAME"
>indexer.conf</TT
> parameters.</P
><P
>"gindex" field corresponds "Index" command. Name is slightly changed to avoid SQL reserved word usage.</P
><P
>Description for several fields see in <A
HREF="dpsearch-dbschema.en.html"
>Section 9.3</A
>&#62;.</P
><DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
><P
><B
>Note: </B
>Only those servers are read from the table where "active"
field has 1 value and "parent" field has 0 value. This is useful to allow users to submit new URLs
into servers table and give administrator a possibility to approve
added URLs.</P
></BLOCKQUOTE
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="FLUSHSRVTABLE"
>3.8.3. Flushing Servers Table</A
></H2
><A
NAME="AEN1222"
></A
><P
> Flush server.enabled to inactive for all server table records. 
Use this command to deactivate all command in servertable before load new from <TT
CLASS="FILENAME"
>indexer.conf</TT
>
or from other servertable.</P
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="dpsearch-aliases.en.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.en.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="dpsearch-pars.en.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Aliases</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="dpsearch-indexing.en.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>External parsers</TD
></TR
></TABLE
></DIV
><!--#include virtual="body-after.html"--></BODY
></HTML
>